1)  log into database via sqlplus as sys or system user and run the following after changing the <directory> to the appropriate filesystem directory

CREATE TABLESPACE "FACD001" 
    LOGGING 
    DATAFILE '<directory>/facd001.dbf' SIZE 10M REUSE 
    EXTENT MANAGEMENT LOCAL;

CREATE USER "FAC"  PROFILE "DEFAULT" 
    IDENTIFIED BY "fac" DEFAULT TABLESPACE "FACD001" 
    TEMPORARY TABLESPACE "TEMP" 
    QUOTA UNLIMITED 
    ON "FACD001" 
    ACCOUNT UNLOCK;
GRANT "CONNECT" TO "FAC";
GRANT "RESOURCE" TO "FAC";

2)  run the following command using the supplied export file

imp system/<password>@<db_name> file=fac.exp \
fromuser=fac_dev \
touser=fac \
grants=Y


3)  run the insert process using the "Default Data.sql" file


ADDENDUM - Basic Environment Information
---------------------------------------- 

O7_DICTIONARY_ACCESSIBILITY =TRUE

_db_file_noncontig_mblock_read_count =1

active_instance_count

always_anti_join =NESTED_LOOPS

always_semi_join=STANDARD

aq_tm_processes=2

audit_file_dest=?/rdbms/audit

audit_trail=TRUE

background_core_dump=partial

background_dump_dest=/orasys/admin/stl_udev/bdump

backup_tape_io_slaves=FALSE

bitmap_merge_area_size=1048576

blank_trimming=FALSE

buffer_pool_keep

buffer_pool_recycle

commit_point_strength=1

compatible=8.1.7

control_file_record_keep_time=7

control_files=/oradat02/stl_udev/control01.ctl, /oradat02/stl_udev/control02.ctl, /oradat02/stl_udev/control03.ctl

core_dump_dest=/orasys/admin/stl_udev/cdump

cpu_count=8

create_bitmap_area_size=8388608

cursor_sharing=EXACT

cursor_space_for_time=FALSE

db_block_buffers=2048

db_block_checking=FALSE

db_block_checksum=FALSE

db_block_lru_latches=4

db_block_max_dirty_target=2048

db_block_size=8192

db_domain=world

db_file_direct_io_count=64

db_file_multiblock_read_count=8

db_file_name_convert

db_files=1021

db_name=stl_udev

db_writer_processes=1

dblink_encrypt_login=FALSE

dbwr_io_slaves =0

disk_asynch_io=TRUE

distributed_transactions=273

dml_locks=4376

enqueue_resources=5417

event=10612 trace name context forever, level 1

fast_start_io_target=0

fast_start_parallel_rollback=LOW

fixed_date=

gc_defer_time=10

gc_files_to_locks=

gc_releasable_locks=0

gc_rollback_locks=0-1024=32!8REACH

global_names=FALSE

hash_area_size=2048000

hash_join_enabled=TRUE

hash_multiblock_io_count=0

hi_shared_memory_address=0

hpux_sched_noage=

hs_autoregister=TRUE

ifile=

instance_groups=

instance_name=studev

instance_number=0

java_max_sessionspace_size=0

java_pool_size=50000000

java_soft_sessionspace_limit=0

job_queue_interval=60

job_queue_processes=1

large_pool_size=60000000

license_max_sessions=0

license_max_users=0

license_sessions_warning=0

lm_locks=12000

lm_ress=6000

local_listener=

lock_name_space=

lock_sga=FALSE

log_archive_dest=

log_archive_dest_1=

log_archive_dest_2=

log_archive_dest_3=

log_archive_dest_4=

log_archive_dest_5=

log_archive_dest_state_1=enable

log_archive_dest_state_2=enable

log_archive_dest_state_3=enable

log_archive_dest_state_4=enable

log_archive_dest_state_5=enable

log_archive_duplex_dest=

log_archive_format=%t_%s.dbf

log_archive_max_processes=1

log_archive_min_succeed_dest=1

log_archive_start=FALSE

log_archive_trace=0

log_buffer=163840

log_checkpoint_interval=10000

log_checkpoint_timeout=1800

log_checkpoints_to_alert=FALSE

log_file_name_convert=

max_commit_propagation_delay=700

max_dump_file_size=UNLIMITED

max_enabled_roles=148

max_rollback_segments=218

mts_circuits=995

mts_dispatchers=(protocol=tcp) (dispatchers=2) (connections=200)

mts_listener_address=

mts_max_dispatchers=5

mts_max_servers=20

mts_multiple_listeners=FALSE

mts_servers=3

mts_service=stl_udev

mts_sessions=990

nls_calendar=

nls_comp=

nls_currency=

nls_date_format=DD-MON-YYYY

nls_date_language=

nls_dual_currency=

nls_iso_currency=

nls_language=AMERICAN

nls_numeric_characters=

nls_sort=

nls_territory=AMERICA

nls_time_format=

nls_time_tz_format=

nls_timestamp_format=

nls_timestamp_tz_format=

object_cache_max_size_percent=10

object_cache_optimal_size=102400

open_cursors=999

open_links=4

open_links_per_instance=4

ops_interconnects=

optimizer_features_enable=8.1.7

optimizer_index_caching=0

optimizer_index_cost_adj=60

optimizer_max_permutations=80000

optimizer_mode=CHOOSE

optimizer_percent_parallel=0

oracle_trace_collection_name=

oracle_trace_collection_path=/otrace/admin/cdf

oracle_trace_collection_size=5242880

oracle_trace_enable=FALSE

oracle_trace_facility_name=oracled

oracle_trace_facility_path=?/otrace/admin/fdf

os_authent_prefix=

os_roles=FALSE

parallel_adaptive_multi_user=FALSE

parallel_automatic_tuning=FALSE

parallel_broadcast_enabled=FALSE

parallel_execution_message_size=2152

parallel_instance_group

parallel_max_servers=5

parallel_min_percent=0

parallel_min_servers=0

parallel_server=FALSE

parallel_server_instances=1

parallel_threads_per_cpu=2

partition_view_enabled=FALSE

plsql_v2_compatibility=FALSE

pre_page_sga=FALSE

processes=900

query_rewrite_enabled=FALSE

query_rewrite_integrity=enforced

rdbms_server_dn=

read_only_open_delayed=FALSE

recovery_parallelism=0

remote_dependencies_mode=tIMESTAMP

remote_login_passwordfile=NONE

remote_os_authent=FALSE

remote_os_roles=FALSE

replication_dependency_tracking=TRUE

resource_limit=FALSE

resource_manager_plan=

rollback_segments=RBS01, RBS02, RBS03, RBS04, RBS05, BIGRBS

row_locking=always

serial_reuse=DISABLE

serializable=FALSE

service_names=stl_udev.world

session_cached_cursors=0

session_max_open_files=10

sessions=995

shadow_core_dump=partial

shared_memory_address=0

shared_pool_reserved_size=7500000

shared_pool_size=150000000

sort_area_retained_size=16384

sort_area_size=1024000

sort_multiblock_read_count=2

sql92_security=FALSE

sql_trace=FALSE

sql_version=NATIVE

standby_archive_dest=?/dbs/arch

star_transformation_enabled=FALSE

tape_asynch_io=TRUE

text_enable=FALSE

thread=0

timed_os_statistics=0

timed_statistics=TRUE

tracefile_identifier=

transaction_auditing=TRUE

transactions=1094

transactions_per_rollback_segment=5

use_indirect_data_buffers=FALSE

user_dump_dest=/orasys/admin/stl_udev/udump

utl_file_dir=/share/oracle/utldir/stl_udev



